SherbyNet - /page/wikibook/entry.mu

Micron Document

`:top

`!Oracle SQL Developer`! is an `F33f`_`[Integrated development environment`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Integrated_development_environment]`_`f (IDE) for working with `F33f`_`[SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f in `F33f`_`[Oracle databases`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Oracle_database]`_`f. `F33f`_`[Oracle Corporation`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Oracle_Corporation]`_`f provides this product `F33f`_`[free`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Freeware]`_`f; it uses the `F33f`_`[Java Development Kit`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Java_Development_Kit]`_`f.

>>Contents

• `F0af`_`[Features`#features]`_`f

• `F0af`_`[Components`#components]`_`f

• `F0af`_`[Extensions`#extensions]`_`f

• `F0af`_`[History`#history]`_`f

• `F0af`_`[See also`#see-also]`_`f

• `F0af`_`[References`#references]`_`f

• `F0af`_`[Bibliography`#bibliography]`_`f

• `F0af`_`[External links`#external-links]`_`f

-─

>>Features

Oracle SQL Developer supports `F33f`_`[Oracle products`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Oracle_database]`_`f. In the past a variety of third-party plugins were supported which users were able to deploy to connect to non-Oracle databases. Oracle SQL Developer worked with `F33f`_`[IBM Db2`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=IBM_Db2]`_`f, `F33f`_`[Microsoft Access`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Microsoft_Access]`_`f, `F33f`_`[Microsoft SQL Server`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Microsoft_SQL_Server]`_`f, `F33f`_`[MySQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=MySQL]`_`f, `F33f`_`[Sybase`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Sybase]`_`f `*Adaptive Server`*, `F33f`_`[Amazon Redshift`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Amazon_Redshift]`_`f and `F33f`_`[Teradata`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Teradata]`_`f databases.`:cite-ref-orasqldevcert-4-0[`F5bf`_`[4`#cite-note-orasqldevcert-4]`_`f]

Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for `F33f`_`[PL/SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=PL/SQL]`_`f.

Future versions of Oracle SQL Developer will use `F33f`_`[Visual Studio Code`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Visual_Studio_Code]`_`f.`:cite-ref-next-1-1[`F5bf`_`[1`#cite-note-next-1]`_`f]

>>Components

Oracle SQL Developer product components include the OWA (Oracle Web Agent or MOD_PLSQL), an extension module for the `F33f`_`[Apache web server`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Apache_HTTP_Server]`_`f, and helps in setting up dynamic web-pages from `F33f`_`[PL/SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=PL/SQL]`_`f within Oracle SQL Developer.`:cite-ref-5[`F5bf`_`[5`#cite-note-5]`_`f]

>>Extensions

In addition to the extensions provided by Oracle, third parties have written extensions to add new features to SQL Developer and to integrate with other products:`:cite-ref-6[`F5bf`_`[6`#cite-note-6]`_`f]

`!Integration with other Oracle products`!

• SQL Developer Data Modeler operates with and models metadata.`:cite-ref-7[`F5bf`_`[7`#cite-note-7]`_`f] Prior to SQL Developer version 3, it constituted a separate (but integrated) free`:cite-ref-8[`F5bf`_`[8`#cite-note-8]`_`f] counterpart of SQL Developer. As of SQL Developer version 3 modeling became an integrated part of the overall tool. "Data Modeler" can produce (among other outputs) .dmd files.`:cite-ref-9[`F5bf`_`[9`#cite-note-9]`_`f]

• Data Miner`:cite-ref-10[`F5bf`_`[10`#cite-note-10]`_`f]

>>History

| Version | Release Date | Description |

|---|---|---|

| Releases prior to 1.0 | | Prior to version 1.0, Oracle Corporation labeled the product " Raptor " |

| 1.0 | March 2006 | The first release |

| 1.1 | December 2006 | |

| 1.2.1 | August 2007 | |

| 1.5 | April 2008 | |

| 1.5.1 | June 2008 | |

| 1.5.3 | December 2008 | |

| 1.5.4 | March 2009 | |

| 1.5.5 | July 2009 | |

| 2.1 RC1 | December 2009 | |

| 2.1 Patch 1 | March 2010 | |

| 3.0 | March 2011 | |

| 3.1 | February 2012 | |

| 3.2 | August 2012 | APEX listener administration; UI enhancements; 12c database support; bug fixes [ 12 ] |

| 4.0 | December 2013 | |

| 4.0.1 | February 2014 | |

| 4.0.2 | May 2014 | |

| 4.0.3 | September 2014 | |

| 4.1.1 | June 2015 | |

| 4.1.2 | October 2015 | Requires Java 8 |

| 4.1.3 | December 2015 | |

| 4.1.5 | September 2016 [ 13 ] | |

| 4.2.0 | April 2017 [ 14 ] | |

| 17.2 | July 2017 [ 15 ] | New version numbering system with year.quarter used. [ 15 ] |

| 17.4 | Dec 2017 [ 16 ] | |

| 18.1 | April 2018 [ 17 ] | |

| 18.2 | July 2018 [ 18 ] | |

| 18.3 | October 2018 [ 19 ] | |

| 18.4 | January 2019 [ 20 ] | |

| 19.1 | April 2019 [ 21 ] | |

| 19.2 | August 2019 [ 22 ] | |

| 19.4 | December 2019 [ 23 ] | |

| 20.2 | June 2020 [ 24 ] | |

| 20.4 | January 2021 [ 25 ] | |

| 20.4.1 | February 2021 [ 26 ] | |

| 21.2 | August 2021 [ 27 ] | |

| 21.4 | December 2021 [ 28 ] | |

| 21.4.2 | January 2022 [ 29 ] | |

| 22.2 | June 2022 [ 30 ] | Requires Oracle Java 11 |

| 22.2.1 | September 2022 [ 31 ] | |

| 23.1 | April 2023 [ 32 ] | |

| 24.3 | October 2024 [ 33 ] | Requires Oracle Java 17 |

| 24.3.1 | December 2024 [ 34 ] | |

>>See also

• `F33f`_`[JDeveloper`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=JDeveloper]`_`f

• `F33f`_`[Oracle Developer Suite`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Oracle_Developer_Suite]`_`f

>>References

`:cite-note-next-1`!1.`! `:citerefsmith2022`aSmith, Jeff (24 October 2022). "What's Next for Oracle SQL Developer? A quick, sneek-peek". `*That Jeff Smith`*. Archived from the original on 8 February 2023. Retrieved 1 May 2023.

`:cite-note-2`!1.`! "Oracle SQL Developer Downloads". Retrieved April 14, 2025.

`:cite-note-3`!2.`! OTN SQL Developer License

`:cite-note-orasqldevcert-4`!4.`! `F0af`_`[↑`#cite-ref-orasqldevcert-4-0]`_`f "Oracle SQL Developer certifications". Oracle Corporation. Retrieved 22 October 2010.

`:cite-note-5`!5.`! `F0af`_`[↑`#cite-ref-5]`_`f `:citerefmurray2007`aMurray, Chuck (September 2007). "1 SQL Developer Concepts and Usage: OWA Output Pane". `*Oracle Database SQL Developer User's Guide Release 1.1`*. Oracle Corporation. Retrieved 2009-02-04. OWA (Oracle Web Agent) or MOD_PLSQL is an Apache (Web Server) extension module.

`:cite-note-6`!6.`! `F0af`_`[↑`#cite-ref-6]`_`f "Oracle SQL Developer - Extensions Exchange". `*oracle.com`*. July 2013. Retrieved 2018-05-22.

`:cite-note-7`!7.`! `F0af`_`[↑`#cite-ref-7]`_`f `:citerefchuck2009`aChuck, Murray (June 2009). "Data Modeler Concepts and Usage" (PDF). `*Oracle SQL Developer Data Modeler User’s Guide Release 2.0`*. Oracle Corporation. p. 1-1. Retrieved 2010-03-12. SQL Developer Data Modeler is a data modeling and database design tool that provides an environment for capturing, modeling, managing, and exploiting metadata.[...] SQL Developer Data Modeler is a for-cost option of SQL Developer that requires a separate license. However, a free viewer (read-only) version is also available [...]

`:cite-note-8`!8.`! `F0af`_`[↑`#cite-ref-8]`_`f "Oracle SQL Developer Data Modeler: Pricing FAQ". Oracle Corpopration. September 2010. Retrieved 2010-10-10. Is Oracle SQL Developer Data Modeler free? - Yes.

`:cite-note-9`!9.`! `F0af`_`[↑`#cite-ref-9]`_`f `:citerefmurray2011`aMurray, Chuck (February 2011). "SQL Developer Data Modeler User's Guide". `*docs.oracle.com`*. Oracle. Retrieved 2014-12-11. When you save a database design, the structural information is stored in an XML file (with the extension .dmd)

`:cite-note-10`!10.`! `F0af`_`[↑`#cite-ref-10]`_`f "Oracle Data Miner".

`:cite-note-11`!3.`! "Oracle SQL Developer". Oracle Corporation. 2008-07-18. Retrieved 2009-02-04.

`:cite-note-12`!4.`! "SQL Developer 3.2 New Features". `*Oracle Technology Network`*. Retrieved 2013-05-01.

`:cite-note-13`!5.`! "SQL Developer Release Notes 4.1.5". `*www.oracle.com`*. Retrieved 2018-03-20.

`:cite-note-14`!6.`! "SQL Developer Release Notes 4.2". `*www.oracle.com`*. Retrieved 2018-03-20.

`:cite-note-relnotes172-15`!7.`! [1] Oracle SQL Developer 17.2 Release Notes

`:cite-note-16`!8.`! "SQL Developer Release Notes 17.4". `*www.oracle.com`*. Retrieved 2018-01-02.

`:cite-note-17`!9.`! "SQL Developer Release Notes 18.1". `*www.oracle.com`*. Retrieved 2018-04-12.

`:cite-note-18`!10.`! "SQL Developer Release Notes 18.2". `*www.oracle.com`*. Retrieved 2018-07-12.

`:cite-note-19`!11.`! "SQL Developer Release Notes 18.3". `*www.oracle.com`*. Retrieved 2019-01-17.

`:cite-note-20`!12.`! "SQL Developer Release Notes 18.4". `*www.oracle.com`*. Retrieved 2019-01-17.

`:cite-note-21`!13.`! "SQL Developer Release Notes 19.1". `*www.oracle.com`*. Retrieved 2019-04-10.

`:cite-note-22`!14.`! "SQL Developer Release Notes 19.2". `*www.oracle.com`*. Retrieved 2019-08-14.

`:cite-note-23`!15.`! "SQL Developer Release Notes 19.4". `*www.oracle.com`*. Retrieved 2019-08-14.

`:cite-note-24`!16.`! "SQL Developer 20.2 Release Notes". `*www.oracle.com`*. Retrieved 2020-07-15.

`:cite-note-25`!17.`! "SQL Developer 20.4 Release Notes". `*www.oracle.com`*. Retrieved 2021-02-18.

`:cite-note-26`!18.`! "SQL Developer 20.4.1 Release Notes". `*www.oracle.com`*. Retrieved 2021-02-24.

`:cite-note-27`!19.`! "SQL Developer 21.2 Release Notes". `*www.oracle.com`*. Retrieved 2021-08-23.

`:cite-note-28`!20.`! "SQL Developer 21.4 Release Notes". `*www.oracle.com`*. Retrieved 2021-12-25.

`:cite-note-29`!21.`! "SQL Developer 21.4.2 Release Notes". `*www.oracle.com`*. Retrieved 2021-12-25.

`:cite-note-30`!22.`! "SQL Developer 22.2 Release Notes". `*www.oracle.com`*. Retrieved 2022-09-13.

`:cite-note-31`!23.`! "SQL Developer 22.2.1 Release Notes". `*www.oracle.com`*. Retrieved 2022-09-13.

`:cite-note-32`!24.`! "SQL Developer 23.1 Release Notes". `*www.oracle.com`*. Retrieved 2023-05-11.

`:cite-note-33`!25.`! "SQL Developer 24.3 Release Notes". `*www.oracle.com`*. Retrieved 2024-11-19.

`:cite-note-34`!26.`! "SQL Developer 24.3.1 Release Notes". `*www.oracle.com`*. Retrieved 2025-04-14.

>>Bibliography

• `:citerefharper2009`aHarper, Sue (October 20, 2009), `*Oracle SQL Developer 2.1`* (1st ed.), `F33f`_`[Packt Publishing`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Packt]`_`f, p. 496, `F33f`_`[ISBN`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ISBN_(identifier)]`_`f 978-1-84719-626-2, retrieved 2010-01-13

• `:citerefhotka2006`aHotka, Dan (October 10, 2006), `*Oracle SQL Developer Handbook`* (1st ed.), `F33f`_`[McGraw-Hill`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=McGraw-Hill]`_`f, p. 230, `F33f`_`[ISBN`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=ISBN_(identifier)]`_`f 0-07-148474-4, retrieved 2010-01-13

>>External links

• Oracle SQL Developer Homepage

`c`F0af`_`[↑ Back to top`#top]`_`f`a